SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[usp_GetRecruitmentTopic]
	(
	@param_type NVARCHAR(50)

	)
	
AS
	/* SET NOCOUNT ON */
	IF @param_type='school'
	BEGIN
	 SET @param_type='校内专场'
	 END
	 ELSE
	 BEGIN
	 IF @param_type='web'
	 BEGIN
	  SET @param_type='网络招聘会'
	 END
	 END
	
	SELECT id,topic FROM dbo.JOL_Recruitment 
	WHERE type= @param_type and state='True' and
			end_time >= getdate()					-- doo 20110215
	ORDER BY verify_time DESC,add_time DESC			-- doo 20110215
	RETURN

GO
